<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>ThinkPHP5.0</title>

    <meta name="description" content="Dashboard">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <!--Basic Styles-->
    <link href="__STATIC__/style/bootstrap.css" rel="stylesheet">
    <link href="__STATIC__/style/font-awesome.css" rel="stylesheet">
    <link href="__STATIC__/style/weather-icons.css" rel="stylesheet">

    <!--Beyond styles-->
    <link id="beyond-link" href="__STATIC__/style/beyond.css" rel="stylesheet" type="text/css">
    <link href="__STATIC__/style/demo.css" rel="stylesheet">
    <link href="__STATIC__/style/typicons.css" rel="stylesheet">
    <link href="__STATIC__/style/animate.css" rel="stylesheet">
   <script src="__STATIC__/js/jquery-1.7.2.min.js"></script>
    <script src="__STATIC__/plus/layer/layer.js"></script>
<style>
.open{
    border: 1px solid #ccc;
padding: 0 3px 0 3px;
cursor: pointer;
}
</style>
</head>

<body>
    <!-- 头部 -->
    {include file="common/head"}

    <!-- /头部 -->

    <div class="main-container container-fluid">
        <div class="page-container">
            <!-- Page Sidebar -->
            <div class="page-sidebar" id="sidebar">
                <!-- Page Sidebar Header-->
                <div class="sidebar-header-wrapper">
                    <input class="searchinput" type="text">
                    <i class="searchicon fa fa-search"></i>
                    <div class="searchhelper">Search Reports, Charts, Emails or Notifications</div>
                </div>
                <!-- /Page Sidebar Header -->
                <!-- Sidebar Menu -->
                {include file="common/left"}
                <!-- /Sidebar Menu -->
            </div>
            <!-- /Page Sidebar -->
            <!-- Page Content -->
            <div class="page-content">
                <!-- Page Breadcrumb -->
                <div class="page-breadcrumbs">
                    <ul class="breadcrumb">
                        <li class="active">

                            <i class="fa fa-home"></i>
                            <a href="{:url('Dataup/index')}">
                                数据库管理
                            </a>
                        </li>
                        <li>所有数据表列表</li>
                    </ul>

                </div>
                <!-- /Page Breadcrumb -->

<!-- Page Body -->
<div class="page-body">

<!-- <button type="button" tooltip="添加备份" class="btn database btn-sm btn-azure btn-addon"
> <i
class="fa fa-plus"></i> 添加备份
</button> -->
<div class="row">
<div class="col-lg-12 col-sm-12 col-xs-12">
<div class="widget">
<div class="widget-body">
<div class="flip-scroll">
<table class="table table-bordered table-hover">
    <thead class="">
        <tr>
            <th class="text-center">表名</th>
            <th class="text-center">记录数</th>
            <th class="text-center">引擎</th>
            <th class="text-center">大小</th>
            <th class="text-center">字符集</th>
            <th class="text-center" width="20%">操作</th>
        </tr>
    </thead>
    <tbody>
        {volist name="list" id="vo"}
        <tr>
            
            <td align="center">{$vo.name}</td>
            <td align="center">{$vo.rows}</td>
            <td align="center">{$vo.engine}</td>
            <td align="center">{:size_format($vo.data_length+$vo.index_length,2)}</td>
            <td align="center">{$vo.collation}</td>
            <td align="center">
                    <a href="javascript:;" onclick="repair('{$vo.name}')" class="btn btn-primary btn-sm shiny">
                        <i class="fa fa-edit"></i>修复
                    </a>
                    <a href="javascript:;" onclick="optimize('{$vo.name}')"
                        class="btn btn-danger btn-sm shiny del"  >
                        <i class="fa fa-trash-o"></i> 优化
                    </a>
                    <a href="javascript:;" data="{$vo.name}" class="btn btn-sm beifen shiny btn-purple">
                        <i class="menu-icon fa fa-bug"></i> 备份
                    </a>
                    <a href="javascript:;" data="{$vo.name}" class="btn btn-sm huanyuan btn-success ">
                            <i class="menu-icon fa fa-briefcase"></i> 还原
                        </a>
                </td>
        </tr>
        {/volist}
     
    
    </tbody>
</table>

</div>
<div>
</div>
</div>
</div>
</div>
</div>

</div>

</div>
            <!-- /Page Body -->
        </div>
        <!-- /Page Content -->
    </div>
    </div>

    <!--Basic Scripts-->
    <script src="__STATIC__/style/jquery_002.js"></script>
    <script src="__STATIC__/style/bootstrap.js"></script>
    <script src="__STATIC__/style/jquery.js"></script>
    <!--Beyond Scripts-->
    <script src="__STATIC__/style/beyond.js"></script>
    <script src="__STATIC__/plus/layer/layer.js"></script>
    <script src="__STATIC__/plus/layui/layui.js"></script>
    <script>
        layui.use(['layer', 'form'], function () {
            var layer = layui.layer;
            var form = layui.form;
            // 全选与取消
            form.on('checkbox(quanxuan)', function (data) {
                if (data.elem.checked) {
                    $('.qx').prop("checked", "checked");
                    form.render();
                } else {
                    $('.qx').prop("checked", "");
                    form.render();
                }

            });
            

        });
        // 还原全部
        $(".hyuan").click(function(){
            $.post("{:url('admin/Dataup/restore')}",{tables:tables},function(res){
                if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }
            })
        });
        // 数据库备份事件
        $(".database").click(function () {
                var name ="database";
                $.post("{:url('admin/Dataup/DbBackup')}",{name:name},function(res){
                if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }
            });
                // layer.open({
                //     type: 2,
                //     title: name+'备份',
                //     area: ['800px', '500px'],
                //     fixed: false, //不固定
                //     maxmin: true,
                //     content: '{:url("Dataup/backuplist")}?name=' + name //数组第二项即吸附元素选择器或者DOM
                // });
            });
          // 备份点击事件
          $(".beifen").click(function () {
                var name = $(this).attr("data");
                $.post("{:url('admin/Dataup/DbBackup')}",{name:name},function(res){
                if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }
            });
                // layer.open({
                //     type: 2,
                //     title: name+'备份',
                //     area: ['800px', '500px'],
                //     fixed: false, //不固定
                //     maxmin: true,
                //     content: '{:url("Dataup/backuplist")}?name=' + name //数组第二项即吸附元素选择器或者DOM
                // });
            });
        // 批量修复
        var tables = "";
        $("#repair").click(function () {
            $("input[type='checkbox']:checkbox:checked").each(function () {
                if($(this).val()=="on"){
                    tables += "";
                }else{
                    tables += $(this).val()+",";
                }
                
            });
            $.post("{:url('admin/Dataup/repairAll')}",{tables:tables},function(res){
                if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }
            })
        });
            //修复
            function repair(tablename) {
                $.post("{:url('admin/Dataup/repair')}", { tablename: tablename }, function (res) {
                   
                    if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }

                }, 'json');
            }
            //优化
            function optimize(tablename) {
                $.post("{:url('admin/Dataup/optimize')}", { tablename: tablename }, function (res) {
                   console.log(res)
                    if (res.code == 1) {
                        layer.msg(res.msg, { time: 1000, icon: 1 });
                    } else {
                        layer.msg(res.msg, { time: 1000, icon: 2 });
                    }
                }, 'json');
            }
            $(function () {
                $(window.parent.document).find('#righttitle').text($('title').text());
            });
    </script>

</body>

</html>